2016-08-09 - 27872 - Break Fix - Adding grouping to OSA172 #CrystalReportsSupport
BREAK FIX
27872 - OSA172 - Risk At Cancel - Add Grouping
Problem Summary
Need to add grouping to OSA172 report for EMEA & Global versions.
Admin Info
| Purpose |
Need to add grouping to OSA172 report for EMEA & Global versions. |
| Requested by |
Mark Harris |
| Issue Date |
08-09-2016 |
| Resolved by |
Dhananjay G |
| Resolved Date |
08-19-2016 |
| Document Status |
Complete |
Detailed Problem Description
Email from Mark Harris on 08/09/2016:
Solution Analysis and Recommendations
1. Need to check if any logic is added in the report for displaying data:
{ZMP_OOCON_ZMP_OOCON_Q021.[0AF_CADATE]-[20AF_CADATE]} <= Dateadd('d',7,currentdate).
2. Need to create new parameter for grouping in the report.
3. Need to add grouping to OSA172 for Global & EMEA Versions similar to OSA175 (Country / Sales Rep / Customer / Period / Doc Number).
4. Need to modify the groups logic in the report based on selection of grouping prompt.
5. Need to validate the report with BEx query.
Test Plan
| Test ID |
Test Scenario |
Expected Results |
| 1 |
Report Format. |
Should be as per NEC crystal standard checklist. |
| 2 |
Execute Crystal Report in Crystal Designer tool after changes. |
Report should execute successfully in Crystal Designer tool. |
| 3 |
Schedule the Report in NEC BI Launch Pad. |
Report should execute successfully in NEC BI Launch Pad. |
Resolution
1. Checked if any logic is added in the report for displaying data:
{ZMP_OOCON_ZMP_OOCON_Q021.[0AF_CADATE]-[20AF_CADATE]} <= Dateadd('d',7,currentdate).
2. Created new parameter for grouping in the report.
3. Added grouping to OSA 172 for Global & EMEA Versions similar to OSA175 (Country / Sales Rep / Customer / Period / Doc Number).
4. Need to modify the groups logic in the report based on selection of grouping prompt.
5. Validated the report with BEx query successfully.
6. Placed the report in BI development and promoted it to BI Production after successful validation.
Release Information
2016-08-17 - 27872 - Rel Notes - Adding grouping to OSA172 - Release 001
2016-08-23 - 27872 - Rel Notes - Adding grouping to OSA172 - Release 002